package com.ly.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import com.ly.bean.Bis_beauty_config;
/**
 * 美研币管理
 * @author Dell
 *
 */
public interface BeautyConfigMapper {

	//查询
	public List<Bis_beauty_config> querybeautyconfig(Bis_beauty_config config);
	
	//删除
	@Delete("delete from bis_beauty_config where config_id=#{config_id}")
	public void del(Integer config_id);
	//根据id查询整条记录
	@Select("select * from bis_beauty_config where config_id=#{config_id}")
	public Bis_beauty_config querybyid(Integer config_id);
	//修改
	@Update("update bis_beauty_config set buy_num=#{buy_num},give_num=#{give_num},modify_time=now(),remark=#{remark} where config_id=#{config_id}")
	public void updateByKey(Bis_beauty_config config);
	//新增
	@Insert("insert into bis_beauty_config values(null,#{buy_num},#{give_num},0,now(),#{create_user_id},now(),#{modify_user_id},#{remark})")
	public void insertconfig(Bis_beauty_config config);

	//查询总条数
	public Integer querycount();
}
